Hệ thống quản lý bán hàng và hàng tồn kho trong c#

37.091 lượt xem;
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="Voucher_DBDataSet" targetNamespace="http://tempuri.org/Voucher_DBDataSet.xsd" xmlns:mstns="http://tempuri.org/Voucher_DBDataSet.xsd" xmlns="http://tempuri.org/Voucher_DBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3   <xs:annotation>
4     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6         <Connections>
7           <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="SIS_DBConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SIS_DBConnectionString1 (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Sales_and_Inventory_System.My.MySettings.GlobalReference.Default.SIS_DBConnectionString1" Provider="System.Data.SqlClient" />
8         </Connections>
9         <Tables>
10           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VoucherTableAdapter" GeneratorDataComponentClassName="VoucherTableAdapter" Name="Voucher" UserDataComponentName="VoucherTableAdapter">
11             <MainSource>
12               <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Voucher" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13                 <DeleteCommand>
14                   <DbCommand CommandType="Text" ModifiedByUser="false">
15                     <CommandText>DELETE FROM [dbo].[Voucher] WHERE (([Id] = @Original_Id) AND ([VoucherNo] = @Original_VoucherNo) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ([Date] = @Original_Date) AND ((@IsNull_Details = 1 AND [Details] IS NULL) OR ([Details] = @Original_Details)) AND ([GrandTotal] = @Original_GrandTotal))</CommandText>
16                     <Parameters>
17                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
18                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_VoucherNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="VoucherNo" SourceColumnNullMapping="false" SourceVersion="Original" />
19                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
20                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
21                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
22                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Details" SourceColumnNullMapping="true" SourceVersion="Original" />
23                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Details" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Details" SourceColumnNullMapping="false" SourceVersion="Original" />
24                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
25                     </Parameters>
26                   </DbCommand>
27                 </DeleteCommand>
28                 <InsertCommand>
29                   <DbCommand CommandType="Text" ModifiedByUser="false">
30                     <CommandText>INSERT INTO [dbo].[Voucher] ([Id], [VoucherNo], [Name], [Date], [Details], [GrandTotal]) VALUES (@Id, @VoucherNo, @Name, @Date, @Details, @GrandTotal);
31 SELECT Id, VoucherNo, Name, Date, Details, GrandTotal FROM Voucher WHERE (Id = @Id)</CommandText>
32                     <Parameters>
33                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
34                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@VoucherNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="VoucherNo" SourceColumnNullMapping="false" SourceVersion="Current" />
35                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
36                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
37                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Details" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Details" SourceColumnNullMapping="false" SourceVersion="Current" />
38                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
39                     </Parameters>
40                   </DbCommand>
41                 </InsertCommand>
42                 <SelectCommand>
43                   <DbCommand CommandType="Text" ModifiedByUser="false">
44                     <CommandText>SELECT Id, VoucherNo, Name, Date, Details, GrandTotal FROM dbo.Voucher</CommandText>
45                     <Parameters />
46                   </DbCommand>
47                 </SelectCommand>
48                 <UpdateCommand>
49                   <DbCommand CommandType="Text" ModifiedByUser="false">
50                     <CommandText>UPDATE [dbo].[Voucher] SET [Id] = @Id, [VoucherNo] = @VoucherNo, [Name] = @Name, [Date] = @Date, [Details] = @Details, [GrandTotal] = @GrandTotal WHERE (([Id] = @Original_Id) AND ([VoucherNo] = @Original_VoucherNo) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ([Date] = @Original_Date) AND ((@IsNull_Details = 1 AND [Details] IS NULL) OR ([Details] = @Original_Details)) AND ([GrandTotal] = @Original_GrandTotal));
51 SELECT Id, VoucherNo, Name, Date, Details, GrandTotal FROM Voucher WHERE (Id = @Id)</CommandText>
52                     <Parameters>
53                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
54                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@VoucherNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="VoucherNo" SourceColumnNullMapping="false" SourceVersion="Current" />
55                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
56                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
57                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Details" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Details" SourceColumnNullMapping="false" SourceVersion="Current" />
58                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
59                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
60                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_VoucherNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="VoucherNo" SourceColumnNullMapping="false" SourceVersion="Original" />
61                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
62                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
63                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
64                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Details" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Details" SourceColumnNullMapping="true" SourceVersion="Original" />
65                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Details" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Details" SourceColumnNullMapping="false" SourceVersion="Original" />
66                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_GrandTotal" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="GrandTotal" SourceColumnNullMapping="false" SourceVersion="Original" />
67                     </Parameters>
68                   </DbCommand>
69                 </UpdateCommand>
70               </DbSource>
71             </MainSource>
72             <Mappings>
73               <Mapping SourceColumn="Id" DataSetColumn="Id" />
74               <Mapping SourceColumn="VoucherNo" DataSetColumn="VoucherNo" />
75               <Mapping SourceColumn="Name" DataSetColumn="Name" />
76               <Mapping SourceColumn="Date" DataSetColumn="Date" />
77               <Mapping SourceColumn="Details" DataSetColumn="Details" />
78               <Mapping SourceColumn="GrandTotal" DataSetColumn="GrandTotal" />
79             </Mappings>
80             <Sources />
81           </TableAdapter>
82           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Voucher_OtherDetailsTableAdapter" GeneratorDataComponentClassName="Voucher_OtherDetailsTableAdapter" Name="Voucher_OtherDetails" UserDataComponentName="Voucher_OtherDetailsTableAdapter">
83             <MainSource>
84               <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Voucher_OtherDetails" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
85                 <DeleteCommand>
86                   <DbCommand CommandType="Text" ModifiedByUser="false">
87                     <CommandText>DELETE FROM [dbo].[Voucher_OtherDetails] WHERE (([VD_ID] = @Original_VD_ID) AND ([VoucherID] = @Original_VoucherID) AND ([Particulars] = @Original_Particulars) AND ([Amount] = @Original_Amount))</CommandText>
88                     <Parameters>
89                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VD_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VD_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
90                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VoucherID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VoucherID" SourceColumnNullMapping="false" SourceVersion="Original" />
91                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Particulars" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Particulars" SourceColumnNullMapping="false" SourceVersion="Original" />
92                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
93                     </Parameters>
94                   </DbCommand>
95                 </DeleteCommand>
96                 <InsertCommand>
97                   <DbCommand CommandType="Text" ModifiedByUser="false">
98                     <CommandText>INSERT INTO [dbo].[Voucher_OtherDetails] ([VoucherID], [Particulars], [Amount], [Note]) VALUES (@VoucherID, @Particulars, @Amount, @Note);
99 SELECT VD_ID, VoucherID, Particulars, Amount, Note FROM Voucher_OtherDetails WHERE (VD_ID = SCOPE_IDENTITY())</CommandText>
100                     <Parameters>
101                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VoucherID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VoucherID" SourceColumnNullMapping="false" SourceVersion="Current" />
102                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Particulars" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Particulars" SourceColumnNullMapping="false" SourceVersion="Current" />
103                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
104                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
105                     </Parameters>
106                   </DbCommand>
107                 </InsertCommand>
108                 <SelectCommand>
109                   <DbCommand CommandType="Text" ModifiedByUser="false">
110                     <CommandText>SELECT VD_ID, VoucherID, Particulars, Amount, Note FROM dbo.Voucher_OtherDetails</CommandText>
111                     <Parameters />
112                   </DbCommand>
113                 </SelectCommand>
114                 <UpdateCommand>
115                   <DbCommand CommandType="Text" ModifiedByUser="false">
116                     <CommandText>UPDATE [dbo].[Voucher_OtherDetails] SET [VoucherID] = @VoucherID, [Particulars] = @Particulars, [Amount] = @Amount, [Note] = @Note WHERE (([VD_ID] = @Original_VD_ID) AND ([VoucherID] = @Original_VoucherID) AND ([Particulars] = @Original_Particulars) AND ([Amount] = @Original_Amount));
117 SELECT VD_ID, VoucherID, Particulars, Amount, Note FROM Voucher_OtherDetails WHERE (VD_ID = @VD_ID)</CommandText>
118                     <Parameters>
119                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VoucherID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VoucherID" SourceColumnNullMapping="false" SourceVersion="Current" />
120                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Particulars" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Particulars" SourceColumnNullMapping="false" SourceVersion="Current" />
121                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
122                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Note" SourceColumnNullMapping="false" SourceVersion="Current" />
123                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VD_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VD_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
124                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VoucherID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VoucherID" SourceColumnNullMapping="false" SourceVersion="Original" />
125                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Particulars" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Particulars" SourceColumnNullMapping="false" SourceVersion="Original" />
126                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Amount" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Original" />
127                       <Parameter AllowDbNull="false" AutogeneratedName="VD_ID" ColumnName="VD_ID" DataSourceName="SIS_DB.dbo.Voucher_OtherDetails" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@VD_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="VD_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
128                     </Parameters>
129                   </DbCommand>
130                 </UpdateCommand>
131               </DbSource>
132             </MainSource>
133             <Mappings>
134               <Mapping SourceColumn="VD_ID" DataSetColumn="VD_ID" />
135               <Mapping SourceColumn="VoucherID" DataSetColumn="VoucherID" />
136               <Mapping SourceColumn="Particulars" DataSetColumn="Particulars" />
137               <Mapping SourceColumn="Amount" DataSetColumn="Amount" />
138               <Mapping SourceColumn="Note" DataSetColumn="Note" />
139             </Mappings>
140             <Sources />
141           </TableAdapter>
142           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CompanyTableAdapter" GeneratorDataComponentClassName="CompanyTableAdapter" Name="Company" UserDataComponentName="CompanyTableAdapter">
143             <MainSource>
144               <DbSource ConnectionRef="SIS_DBConnectionString1 (MySettings)" DbObjectName="SIS_DB.dbo.Company" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
145                 <DeleteCommand>
146                   <DbCommand CommandType="Text" ModifiedByUser="false">
147                     <CommandText>DELETE FROM [dbo].[Company] WHERE (([ID] = @Original_ID) AND ([CompanyName] = @Original_CompanyName) AND ([Address] = @Original_Address) AND ([ContactNo] = @Original_ContactNo) AND ([EmailID] = @Original_EmailID) AND ((@IsNull_TIN = 1 AND [TIN] IS NULL) OR ([TIN] = @Original_TIN)) AND ((@IsNull_STNo = 1 AND [STNo] IS NULL) OR ([STNo] = @Original_STNo)) AND ((@IsNull_CIN = 1 AND [CIN] IS NULL) OR ([CIN] = @Original_CIN)))</CommandText>
148                     <Parameters>
149                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
150                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CompanyName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Original" />
151                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
152                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
153                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
154                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="true" SourceVersion="Original" />
155                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="false" SourceVersion="Original" />
156                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="true" SourceVersion="Original" />
157                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_STNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="false" SourceVersion="Original" />
158                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="true" SourceVersion="Original" />
159                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="false" SourceVersion="Original" />
160                     </Parameters>
161                   </DbCommand>
162                 </DeleteCommand>
163                 <InsertCommand>
164                   <DbCommand CommandType="Text" ModifiedByUser="false">
165                     <CommandText>INSERT INTO [dbo].[Company] ([CompanyName], [Address], [ContactNo], [EmailID], [Logo], [TIN], [STNo], [CIN]) VALUES (@CompanyName, @Address, @ContactNo, @EmailID, @Logo, @TIN, @STNo, @CIN);
166 SELECT ID, CompanyName, Address, ContactNo, EmailID, Logo, TIN, STNo, CIN FROM Company WHERE (ID = SCOPE_IDENTITY())</CommandText>
167                     <Parameters>
168                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
169                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
170                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
171                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
172                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Current" />
173                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="false" SourceVersion="Current" />
174                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@STNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="false" SourceVersion="Current" />
175                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="false" SourceVersion="Current" />
176                     </Parameters>
177                   </DbCommand>
178                 </InsertCommand>
179                 <SelectCommand>
180                   <DbCommand CommandType="Text" ModifiedByUser="false">
181                     <CommandText>SELECT ID, CompanyName, Address, ContactNo, EmailID, Logo, TIN, STNo, CIN FROM dbo.Company</CommandText>
182                     <Parameters />
183                   </DbCommand>
184                 </SelectCommand>
185                 <UpdateCommand>
186                   <DbCommand CommandType="Text" ModifiedByUser="false">
187                     <CommandText>UPDATE [dbo].[Company] SET [CompanyName] = @CompanyName, [Address] = @Address, [ContactNo] = @ContactNo, [EmailID] = @EmailID, [Logo] = @Logo, [TIN] = @TIN, [STNo] = @STNo, [CIN] = @CIN WHERE (([ID] = @Original_ID) AND ([CompanyName] = @Original_CompanyName) AND ([Address] = @Original_Address) AND ([ContactNo] = @Original_ContactNo) AND ([EmailID] = @Original_EmailID) AND ((@IsNull_TIN = 1 AND [TIN] IS NULL) OR ([TIN] = @Original_TIN)) AND ((@IsNull_STNo = 1 AND [STNo] IS NULL) OR ([STNo] = @Original_STNo)) AND ((@IsNull_CIN = 1 AND [CIN] IS NULL) OR ([CIN] = @Original_CIN)));
188 SELECT ID, CompanyName, Address, ContactNo, EmailID, Logo, TIN, STNo, CIN FROM Company WHERE (ID = @ID)</CommandText>
189                     <Parameters>
190                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CompanyName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Current" />
191                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
192                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Current" />
193                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Current" />
194                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Logo" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Logo" SourceColumnNullMapping="false" SourceVersion="Current" />
195                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="false" SourceVersion="Current" />
196                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@STNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="false" SourceVersion="Current" />
197                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="false" SourceVersion="Current" />
198                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
199                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CompanyName" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CompanyName" SourceColumnNullMapping="false" SourceVersion="Original" />
200                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
201                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ContactNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ContactNo" SourceColumnNullMapping="false" SourceVersion="Original" />
202                       <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_EmailID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="EmailID" SourceColumnNullMapping="false" SourceVersion="Original" />
203                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="true" SourceVersion="Original" />
204                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TIN" SourceColumnNullMapping="false" SourceVersion="Original" />
205                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="true" SourceVersion="Original" />
206                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_STNo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="STNo" SourceColumnNullMapping="false" SourceVersion="Original" />
207                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CIN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="true" SourceVersion="Original" />
208                       <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CIN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="CIN" SourceColumnNullMapping="false" SourceVersion="Original" />
209                       <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
210                     </Parameters>
211                   </DbCommand>
212                 </UpdateCommand>
213               </DbSource>
214             </MainSource>
215             <Mappings>
216               <Mapping SourceColumn="ID" DataSetColumn="ID" />
217               <Mapping SourceColumn="CompanyName" DataSetColumn="CompanyName" />
218               <Mapping SourceColumn="Address" DataSetColumn="Address" />
219               <Mapping SourceColumn="ContactNo" DataSetColumn="ContactNo" />
220               <Mapping SourceColumn="EmailID" DataSetColumn="EmailID" />
221               <Mapping SourceColumn="Logo" DataSetColumn="Logo" />
222               <Mapping SourceColumn="TIN" DataSetColumn="TIN" />
223               <Mapping SourceColumn="STNo" DataSetColumn="STNo" />
224               <Mapping SourceColumn="CIN" DataSetColumn="CIN" />
225             </Mappings>
226             <Sources />
227           </TableAdapter>
228         </Tables>
229         <Sources />
230       </DataSource>
231     </xs:appinfo>
232   </xs:annotation>
233   <xs:element name="Voucher_DBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Voucher_DBDataSet" msprop:Generator_UserDSName="Voucher_DBDataSet">
234     <xs:complexType>
235       <xs:choice minOccurs="0" maxOccurs="unbounded">
236         <xs:element name="Voucher" msprop:Generator_TableClassName="VoucherDataTable" msprop:Generator_TableVarName="tableVoucher" msprop:Generator_RowChangedName="VoucherRowChanged" msprop:Generator_TablePropName="Voucher" msprop:Generator_RowDeletingName="VoucherRowDeleting" msprop:Generator_RowChangingName="VoucherRowChanging" msprop:Generator_RowEvHandlerName="VoucherRowChangeEventHandler" msprop:Generator_RowDeletedName="VoucherRowDeleted" msprop:Generator_RowClassName="VoucherRow" msprop:Generator_UserTableName="Voucher" msprop:Generator_RowEvArgName="VoucherRowChangeEvent">
237           <xs:complexType>
238             <xs:sequence>
239               <xs:element name="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
240               <xs:element name="VoucherNo" msprop:Generator_ColumnVarNameInTable="columnVoucherNo" msprop:Generator_ColumnPropNameInRow="VoucherNo" msprop:Generator_ColumnPropNameInTable="VoucherNoColumn" msprop:Generator_UserColumnName="VoucherNo">
241                 <xs:simpleType>
242                   <xs:restriction base="xs:string">
243                     <xs:maxLength value="30" />
244                   </xs:restriction>
245                 </xs:simpleType>
246               </xs:element>
247               <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
248                 <xs:simpleType>
249                   <xs:restriction base="xs:string">
250                     <xs:maxLength value="150" />
251                   </xs:restriction>
252                 </xs:simpleType>
253               </xs:element>
254               <xs:element name="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="_Date" msprop:Generator_ColumnPropNameInTable="DateColumn" msprop:Generator_UserColumnName="Date" type="xs:dateTime" />
255               <xs:element name="Details" msprop:Generator_ColumnVarNameInTable="columnDetails" msprop:Generator_ColumnPropNameInRow="Details" msprop:Generator_ColumnPropNameInTable="DetailsColumn" msprop:Generator_UserColumnName="Details" minOccurs="0">
256                 <xs:simpleType>
257                   <xs:restriction base="xs:string">
258                     <xs:maxLength value="10" />
259                   </xs:restriction>
260                 </xs:simpleType>
261               </xs:element>
262               <xs:element name="GrandTotal" msprop:Generator_ColumnVarNameInTable="columnGrandTotal" msprop:Generator_ColumnPropNameInRow="GrandTotal" msprop:Generator_ColumnPropNameInTable="GrandTotalColumn" msprop:Generator_UserColumnName="GrandTotal" type="xs:decimal" />
263             </xs:sequence>
264           </xs:complexType>
265         </xs:element>
266         <xs:element name="Voucher_OtherDetails" msprop:Generator_TableClassName="Voucher_OtherDetailsDataTable" msprop:Generator_TableVarName="tableVoucher_OtherDetails" msprop:Generator_RowChangedName="Voucher_OtherDetailsRowChanged" msprop:Generator_TablePropName="Voucher_OtherDetails" msprop:Generator_RowDeletingName="Voucher_OtherDetailsRowDeleting" msprop:Generator_RowChangingName="Voucher_OtherDetailsRowChanging" msprop:Generator_RowEvHandlerName="Voucher_OtherDetailsRowChangeEventHandler" msprop:Generator_RowDeletedName="Voucher_OtherDetailsRowDeleted" msprop:Generator_RowClassName="Voucher_OtherDetailsRow" msprop:Generator_UserTableName="Voucher_OtherDetails" msprop:Generator_RowEvArgName="Voucher_OtherDetailsRowChangeEvent">
267           <xs:complexType>
268             <xs:sequence>
269               <xs:element name="VD_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnVD_ID" msprop:Generator_ColumnPropNameInRow="VD_ID" msprop:Generator_ColumnPropNameInTable="VD_IDColumn" msprop:Generator_UserColumnName="VD_ID" type="xs:int" />
270               <xs:element name="VoucherID" msprop:Generator_ColumnVarNameInTable="columnVoucherID" msprop:Generator_ColumnPropNameInRow="VoucherID" msprop:Generator_ColumnPropNameInTable="VoucherIDColumn" msprop:Generator_UserColumnName="VoucherID" type="xs:int" />
271               <xs:element name="Particulars" msprop:Generator_ColumnVarNameInTable="columnParticulars" msprop:Generator_ColumnPropNameInRow="Particulars" msprop:Generator_ColumnPropNameInTable="ParticularsColumn" msprop:Generator_UserColumnName="Particulars">
272                 <xs:simpleType>
273                   <xs:restriction base="xs:string">
274                     <xs:maxLength value="200" />
275                   </xs:restriction>
276                 </xs:simpleType>
277               </xs:element>
278               <xs:element name="Amount" msprop:Generator_ColumnVarNameInTable="columnAmount" msprop:Generator_ColumnPropNameInRow="Amount" msprop:Generator_ColumnPropNameInTable="AmountColumn" msprop:Generator_UserColumnName="Amount" type="xs:decimal" />
279               <xs:element name="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" msprop:Generator_UserColumnName="Note" minOccurs="0">
280                 <xs:simpleType>
281                   <xs:restriction base="xs:string">
282                     <xs:maxLength value="2147483647" />
283                   </xs:restriction>
284                 </xs:simpleType>
285               </xs:element>
286             </xs:sequence>
287           </xs:complexType>
288         </xs:element>
289         <xs:element name="Company" msprop:Generator_TableClassName="CompanyDataTable" msprop:Generator_TableVarName="tableCompany" msprop:Generator_TablePropName="Company" msprop:Generator_RowDeletingName="CompanyRowDeleting" msprop:Generator_RowChangingName="CompanyRowChanging" msprop:Generator_RowEvHandlerName="CompanyRowChangeEventHandler" msprop:Generator_RowDeletedName="CompanyRowDeleted" msprop:Generator_UserTableName="Company" msprop:Generator_RowChangedName="CompanyRowChanged" msprop:Generator_RowEvArgName="CompanyRowChangeEvent" msprop:Generator_RowClassName="CompanyRow">
290           <xs:complexType>
291             <xs:sequence>
292               <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
293               <xs:element name="CompanyName" msprop:Generator_ColumnVarNameInTable="columnCompanyName" msprop:Generator_ColumnPropNameInRow="CompanyName" msprop:Generator_ColumnPropNameInTable="CompanyNameColumn" msprop:Generator_UserColumnName="CompanyName">
294                 <xs:simpleType>
295                   <xs:restriction base="xs:string">
296                     <xs:maxLength value="200" />
297                   </xs:restriction>
298                 </xs:simpleType>
299               </xs:element>
300               <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address">
301                 <xs:simpleType>
302                   <xs:restriction base="xs:string">
303                     <xs:maxLength value="250" />
304                   </xs:restriction>
305                 </xs:simpleType>
306               </xs:element>
307               <xs:element name="ContactNo" msprop:Generator_ColumnVarNameInTable="columnContactNo" msprop:Generator_ColumnPropNameInRow="ContactNo" msprop:Generator_ColumnPropNameInTable="ContactNoColumn" msprop:Generator_UserColumnName="ContactNo">
308                 <xs:simpleType>
309                   <xs:restriction base="xs:string">
310                     <xs:maxLength value="150" />
311                   </xs:restriction>
312                 </xs:simpleType>
313               </xs:element>
314               <xs:element name="EmailID" msprop:Generator_ColumnVarNameInTable="columnEmailID" msprop:Generator_ColumnPropNameInRow="EmailID" msprop:Generator_ColumnPropNameInTable="EmailIDColumn" msprop:Generator_UserColumnName="EmailID">
315                 <xs:simpleType>
316                   <xs:restriction base="xs:string">
317                     <xs:maxLength value="150" />
318                   </xs:restriction>
319                 </xs:simpleType>
320               </xs:element>
321               <xs:element name="Logo" msprop:Generator_ColumnVarNameInTable="columnLogo" msprop:Generator_ColumnPropNameInRow="Logo" msprop:Generator_ColumnPropNameInTable="LogoColumn" msprop:Generator_UserColumnName="Logo" type="xs:base64Binary" />
322               <xs:element name="TIN" msprop:Generator_ColumnVarNameInTable="columnTIN" msprop:Generator_ColumnPropNameInRow="TIN" msprop:Generator_ColumnPropNameInTable="TINColumn" msprop:Generator_UserColumnName="TIN" minOccurs="0">
323                 <xs:simpleType>
324                   <xs:restriction base="xs:string">
325                     <xs:maxLength value="150" />
326                   </xs:restriction>
327                 </xs:simpleType>
328               </xs:element>
329               <xs:element name="STNo" msprop:Generator_ColumnVarNameInTable="columnSTNo" msprop:Generator_ColumnPropNameInRow="STNo" msprop:Generator_ColumnPropNameInTable="STNoColumn" msprop:Generator_UserColumnName="STNo" minOccurs="0">
330                 <xs:simpleType>
331                   <xs:restriction base="xs:string">
332                     <xs:maxLength value="150" />
333                   </xs:restriction>
334                 </xs:simpleType>
335               </xs:element>
336               <xs:element name="CIN" msprop:Generator_ColumnVarNameInTable="columnCIN" msprop:Generator_ColumnPropNameInRow="CIN" msprop:Generator_ColumnPropNameInTable="CINColumn" msprop:Generator_UserColumnName="CIN" minOccurs="0">
337                 <xs:simpleType>
338                   <xs:restriction base="xs:string">
339                     <xs:maxLength value="150" />
340                   </xs:restriction>
341                 </xs:simpleType>
342               </xs:element>
343             </xs:sequence>
344           </xs:complexType>
345         </xs:element>
346       </xs:choice>
347     </xs:complexType>
348     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
349       <xs:selector xpath=".//mstns:Voucher" />
350       <xs:field xpath="mstns:Id" />
351     </xs:unique>
352     <xs:unique name="Voucher_OtherDetails_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
353       <xs:selector xpath=".//mstns:Voucher_OtherDetails" />
354       <xs:field xpath="mstns:VD_ID" />
355     </xs:unique>
356     <xs:unique name="Company_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
357       <xs:selector xpath=".//mstns:Company" />
358       <xs:field xpath="mstns:ID" />
359     </xs:unique>
360   </xs:element>
361   <xs:annotation>
362     <xs:appinfo>
363       <msdata:Relationship name="FK_Voucher_OtherDetails_Voucher" msdata:parent="Voucher" msdata:child="Voucher_OtherDetails" msdata:parentkey="Id" msdata:childkey="VoucherID" msprop:Generator_UserChildTable="Voucher_OtherDetails" msprop:Generator_ChildPropName="GetVoucher_OtherDetailsRows" msprop:Generator_UserRelationName="FK_Voucher_OtherDetails_Voucher" msprop:Generator_RelationVarName="relationFK_Voucher_OtherDetails_Voucher" msprop:Generator_UserParentTable="Voucher" msprop:Generator_ParentPropName="VoucherRow" />
364     </xs:appinfo>
365   </xs:annotation>
366 </xs:schema>


Web, Tìm kết quả nhanh

Kích thước hoặc độ phức tạp của bản gửi này, tác giả đã gửi nó dưới dạng tệp .zip để rút ngắn thời gian tải xuống của bạn. Sau khi tải xuống, bạn sẽ cần một chương trình như Winzip để giải nén nó.

Tất cả các tệp đều được codefly.vn quét mỗi ngày một lần để tìm vi-rút, nhưng vi-rút mới xuất hiện hàng ngày nên không có chương trình phòng ngừa nào có thể bắt được 100% chúng.

ĐỂ AN TOÀN CỦA CHÍNH BẠN, VUI LÒNG:

1. Quét lại các tệp đã tải xuống bằng trình kiểm tra vi-rút cá nhân của bạn trước khi sử dụng.

2. KHÔNG BAO GIỜ, chạy các tệp đã biên dịch (.exe's, .ocx's, .dll's, v.v.)--chỉ chạy code mà bạn đã xem ít nhất 1 lần.

Official Website:

https://www.techprofree.com/.....c-with-source-code/

Gõ tìm kiếm nhanh...



Dự án liên quan!

Cách tạo đồng hồ bấm giờ trong C#

67 lượt xem

Hệ thống quản lý hàng tồn kho sử dụng cơ sở dữ liệu VB.NET và MySQL với mã nguồn

67 lượt xem

Đếm nguyên âm và phụ âm

111 lượt xem

Phần mềm quản lý nhân viên hiện đại sử dụng C#.net và Bunifu Framework với Full Source Code (2020)

171 lượt xem

Hệ thống quản lý đại học bằng C# với mã nguồn đầy đủ

135 lượt xem

Hệ thống quản lý bệnh viện bằng C# với mã nguồn đầy đủ

152 lượt xem